[dbo].[BAEFinalizePOForOrder]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEFinalizePOForOrder

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@poVal	varchar(48)	48
@orderNum	int	4

SQL Script

create procedure [dbo].[BAEFinalizePOForOrder] @poVal varchar(48),
     @orderNum int as
UPDATE Orders
        SET CUSTOMER_REFERENCE = @poVal, PAY_TYPE = ''
        WHERE ORDER_NUMBER = @orderNum

GO

Uses

[dbo].[Orders]
dbo